# coding=utf-8
# !/usr/bin/env/ python3
# -*- coding: utf-8 -*-
import pandas as pd
import os.path
import os


# def xls2xlsx(dir):
#     rootdir = dir
#     files = os.listdir(rootdir)
#     num = len(files)
#     for i in range(num):
#         path = rootdir + files[i]
#         a = files[i].split('.')
#         b = rootdir + a[0] + '.xlsx'
#         x = pd.read_excel(path)
#         x.to_excel(b, index=False)

dir = 'F:\python\XU22\TEST_DIR\\allreport'
# xls2xlsx(dir)


file = dir + '/allCase.xls'

import pandas as pd
x = pd.read_excel(file)
x.to_excel(dir + '/allCase.xlsx', index=True)